## Assessment 7

## PHP MySQL Real Estate Site (Programming Assignment 2)

Version:3.0 – Updated Feb 2019 Course Code: New Zealand Diploma in Web Development and Design (NZDWDD5) Level: 5 Credits: 31.5 	

Due Date: Week 28 out of 32 	Passing Grade: 50% 	

Modules Assessed: 

- W104 -Database Design and Integration 	

- W105 -Introduction to Software Programming 	

- W106 -Software Testing and Security 	

- W107 -Professional Practice 

  ------

  Learning Outcomes:

  

  ### W104 - Database Design and Integration 

  1. Design relational databases using SQL or suitable Data Access Service 

  2. Design relational databases using entity-relationship modelling 

  3. Demonstrate their understanding of database concepts through the creation of practical database solutions

  4. Perform a range of Query Language queries 

  5. Design and implement appropriate application data access, management, and storage technologies to match the application domain

  6. Integrate databases with web applications using a Data Access Service  

     

  ### W105 -Introduction to Software Programming

1. Write clean quality code using the best coding conventions

2. Identify the characteristics and benefits of and apply structure diagrams, pseudo code, flow charts and knowledge of iterations to solve software problems

3. Create accurate and clear technical and user documentation

4. Create and run Unit Tests

   

   ### W106 -Software Testing and Security

1. Design a variety of tests including unit and system tests, usability testing, user acceptance tests 

2. Test on a range of platforms, e.g., multiple devices and environments 

3. Move a solution from a test environment to a live platform

4. Produce user training material

   

   ### W107 -Professional Practice

   1. Demonstrate professional behavior
   2. Demonstrate communication, information design skills, report and technical writing
   3. Demonstrate personal and interpersonal skills, including teamwork, customer service

   

   **Files Required for Submission:**   

   - **ZippedSite Root Folder**
   - **Relational Database Schema**
   - **Exported Database**
   - **Change and Testing Document**
   - **Peer Review Sheet**

------

**Purpose:**	By completing this assessment, students will show that they have learntkey skills taught in PHP.	This assessment tests your skills in PHP development, MySQL database design and SQL manipulations.

**Requirements:**	You must create a Real Estate website that allows users to search for properties for sale via city. The website will be a peer assignment where each person completes 50% of the work. You must use your best judgement and skills that you have learnt to create this website, creating features as necessary to enhance user experience. 

**The website must have at least the following functional features split between each person:**

**Person 1**

- Home page showing all properties from Database

- At least the following pages:

  ​	Browse categories result page

  ​	Browse single property

  ​	View wish listo

  ​	Add properties to wish list 

  ​	Delete properties from wish list

**Joint  **

- Design and style of website including CSS
- Sign up and login (to gain wish list functionality)
- Design and implement database schema
- Unit testing for PHP function
- Adding image via URL or optionally using image uploading.

**Person 2**

- Admin dashboard

- Secured administrator pages that allow the following functionality:

  ​	Add real estate listings

  ​	Edit real estate listings

  ​	Delete real estate listing
  
  You will each need to fill in a peer review to assess how each person worked.	Each person needs to create a diary/documentation detailing progress and timeline of features. 	Your assignment will need to be submitted as one project. 	Alternatively, you can use GitHubto show workload andfor submissions. 	Both students will need to present their assignment to the class, explaining the functionality and what features they implemented.

**Design**

- You will need to create a fictional Real Estate company for use with your website. 

- You must create the following information and items for your company:

  ​	A business name

  ​	Logoo

  ​	Colour scheme

  ​	Contact details (Phone, address, email)

  ​	Your websites design must reflect your fictional company’s logo and colour scheme. 

  ​	The design should be modern and follow your initial draft.

**Database**

- You must develop your database using MySQL within phpMyAdmin of XAMPP. 
- The database must reflect your initial planned tables and data types. 

**Development**

Your website must be developed using PHP and MySQL database.  Use PHP functions where appropriate.  You must use the PHP for all server side processing.

- Build and develop the website according to your database design. 
- Test your website thoroughly before submission. This will most likely involve debugging any issues
- All potential errors must be caught and validated
- Your HTML and CSS must be HTML5 compliant. Your CSS must be efficient.

**Marking scheme**

You will be assessed on the fulfilment of all points listed above. You must present and demonstrate your website and your tutor must sign off your website before you submit your work. You will also be marked on your conduct, approach and work ethic during the development process of your website. Good attendance and work ethic is a requirement to pass this assessment. CMS are not appropriate for this assignment.

